A standard list is comprised of a set of static or dynamic member elements. These may be selected directly from the data model, imported from a list, or referenced from an existing custom list.
Syntax & Usage
- Manually select the elements from the list (orange highlight).
- Open the list builder (blue arrow) to import and auto-select a list of elements.
- Select an existing custom list. To do this, click the Business Logic icon (green arrow) to expose existing custom lists that have been saved to the data model (green highlight).
Example
This example returns a list of four manufacturers; Acme, Adihash, Esics, and Nuke:
{[manufacturers].[Manufacturer].[Acme],[manufacturers].[Manufacturer].[Adihash],[manufacturers].[Manufacturer].[Esics],[manufacturers].[Manufacturer].[Nuke]}
Related information
Members Search in Discover
You can, alternatively, create a standard list using the Members Search in Discover. Use the Members Search to search for and find hierarchy elements and then select the Save As List option to save your Selected Elements as a List. You can open the List in Formulate using the right-click Open in Formulate option.
- Click here for more information